Create Database
Description
The step is used to create a database in MSSQL server.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server Name | The Hostname/Server Name/IP of the MSSQL Server. This field is mandatory. Drop down is available. |
| 3 | Instance name | The instance name of MSSQL Server instance. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 4 | Port | The port number of the MSSQL Server. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 5 | Username | A username of the MSSQL Server. This field is mandatory. |
| Password | ||
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for previous step fields. Test Connection button only works with static values and environment variables. |
| Input Fields | ||
| 1 | Database Name | The name of the new database to be created. |
| Output Field | ||
| 1 | Result | Output field to hold the result of successful plugin execution. This field is mandatory. Error Handling: Refer Error Handling |